SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{1afa31a1f220a79340383a3681b1846ac0d6c378af661c6e9b18cb8d7090664a}Aachen{1afa31a1f220a79340383a3681b1846ac0d6c378af661c6e9b18cb8d7090664a}' OR prCity = 'Aachen' OR prZip = 'Aachen' OR prStreet LIKE '{1afa31a1f220a79340383a3681b1846ac0d6c378af661c6e9b18cb8d7090664a}Aachen{1afa31a1f220a79340383a3681b1846ac0d6c378af661c6e9b18cb8d7090664a}' OR prCountry = 'Aachen') AND (prLocation LIKE '{1afa31a1f220a79340383a3681b1846ac0d6c378af661c6e9b18cb8d7090664a}/{1afa31a1f220a79340383a3681b1846ac0d6c378af661c6e9b18cb8d7090664a}' OR prCity = '/' OR prZip = '/' OR prStreet LIKE '{1afa31a1f220a79340383a3681b1846ac0d6c378af661c6e9b18cb8d7090664a}/{1afa31a1f220a79340383a3681b1846ac0d6c378af661c6e9b18cb8d7090664a}' OR prCountry = '/') AND (prLocation LIKE '{1afa31a1f220a79340383a3681b1846ac0d6c378af661c6e9b18cb8d7090664a}Haaren{1afa31a1f220a79340383a3681b1846ac0d6c378af661c6e9b18cb8d7090664a}' OR prCity = 'Haaren' OR prZip = 'Haaren' OR prStreet LIKE '{1afa31a1f220a79340383a3681b1846ac0d6c378af661c6e9b18cb8d7090664a}Haaren{1afa31a1f220a79340383a3681b1846ac0d6c378af661c6e9b18cb8d7090664a}' OR prCountry = 'Haaren') AND (prLocation LIKE '{1afa31a1f220a79340383a3681b1846ac0d6c378af661c6e9b18cb8d7090664a}Germany{1afa31a1f220a79340383a3681b1846ac0d6c378af661c6e9b18cb8d7090664a}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{1afa31a1f220a79340383a3681b1846ac0d6c378af661c6e9b18cb8d7090664a}Germany{1afa31a1f220a79340383a3681b1846ac0d6c378af661c6e9b18cb8d7090664a}' OR prCountry = 'Germany')